﻿

if not Exists(select * from sysobjects where name = 'NewsLetterEmailRecipient' and Xtype = 'U') 
Begin

	Create table dbo.NewsLetterEmailRecipient (
		Id int identity(1,1) not null,
		PresentationId int null,
		FirstName varchar(50) null,
		LastName varchar(50) null,
		FullName varchar(200) null,
		Email varchar(100) not null,
		CorporateName varchar(100) null,
		UnsubscriptionId int null
	)

	alter table dbo.NewsLetterEmailRecipient add constraint PK_NewsLetterEmailRecipient_Id primary key nonclustered (Id)

	create unique clustered Index IX_NewsLetterEmailRecipient_Email on NewsLetterEmailRecipient(Email)

End